$webwork.htmlEncode($page.space.name) : Loading TIGER otherstuff
This page last changed on Mar 02, 2006 by dblasby.
a. giant polygon
CREATE TABLE giant_polygon AS
SELECT envelope('BOX3D(-180 -90,180 90)'::box3d) as the_geom;
10. geometry_columns
insert into geometry_columns values ('','public','point_landmark','wkb_geometry',2,1,'GEOMETRY');
insert into geometry_columns values ('','public','poly_landmarks','buffer',2,1,'GEOMETRY');
insert into geometry_columns values ('','public','finalroads','wkb_geometry',2,1,'GEOMETRY');
insert into geometry_columns values ('','public','giant_polygon','the_geom',2,-1,'GEOMETRY');
11. load into geoserver:
A) point_landmark - label points & mark
B) poly_landmark - label and colour
C) roads - wide and label
D) giant polygon
12. indexes
CREATE index point_landmark_idx on point_landmark using gist (wkb_geometry gist_geometry_ops); CREATE index poly_landmarks_idx on poly_landmarks using gist (buffer gist_geometry_ops); CREATE index finalroads_idx on finalroads using gist (wkb_geometry gist_geometry_ops); analyse;
13. WATER - lines
 | Fill in later |
14. WATER - polygons
| Fill in later |
